package rohyunji;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

public interface _IDAO {
	
//	DB연결부분
	Connection openDataBase();
	void closeDataBase(Connection c,PreparedStatement p,ResultSet rs);
	
//	각 DB등록부분
	boolean InsertMember(MemberVO mv);
	boolean InsertCompany(CompanyVO cv);
//	boolean InsertAnnounce(AnnounceVO acv);
//	boolean InsertResume(ResumeVO rv);
	
//	각 DB selcet문 
	List <MemberVO> SelectMember(MemberVO mv);
	List <CompanyVO> SelectCompany(CompanyVO cv);
//	List <AnnounceVO> SelectAnnounce(AnnounceVO acv);
//	List <ResumeVO> SelectResume(ResumeVO rv);
	
	
//	각DB Update문
	boolean UpdateMember(MemberVO mv);
	boolean UpdateCompany(CompanyVO cv);
//	boolean UpdateAnnounce(AnnounceVO acv);
//	boolean UpdateResume(ResumeVO rv);
//	

//	Delete문,중복값검사 (count이용)
	int  countMember(MemberVO mv);
	int  countCompany(CompanyVO cv);
//	int  countAnnounce(AnnounceVO acv);
//	int  countResume(ResumeVO rv);
	
	boolean deleteCompany(CompanyVO cv);
	
	List<CompanyVO> selectCp_no(CompanyVO cv);
	

	

}
